SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_SearchPathById]

	@param_Id int

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	select a.resume_path	from JOL_Recruitment_ApplyingRecords as a,	JOL_Recruitment_Position as b,	JOL_Recruitment_Participants_apply as c,	JOL_Recruitment as d	where d.id = @param_Id 	and d.id = c.recruitment	and c.id = b.participants_apply	and b.id = a.recruit_position
END
GO
